Insert Or Delete Rows

AutomatR.Excel.Activities.InsertOrDeleteRows

The "Insert or Delete Rows" activity in AutomatR is part of the Excel activities package, designed to dynamically add or remove rows in Microsoft Excel based on the specified index or position. This activity provides flexibility in adjusting the structure of Excel worksheets, enhancing automation capabilities.

Properties

Name	Description
Input
Action Type	Select the operation to either insert or delete rows. Options: Insert, Delete.
Index	Enter the index or position where the row addition or deletion occurs. Integer variables containing the index value.
No. Of Rows	Enter the number of rows you wish to add or remove. Integer variables containing the number of rows.
Misc
Display Name	The display name of the activity. A display name is automatically generated when you indicate a target.
Optional
Delay	Enter the wait time in seconds (Example 5 seconds, i.e., 5) to start the activity. Integer variables containing the delay duration.

How to use:

1. Drag and drop the "Insert or Delete Rows" activity onto the workflow.
2. Configure the properties by specifying the action type (insert or delete), index, and the number of rows.
3. Optionally, configure the delay.
4. Execute the workflow to dynamically insert or delete rows based on the specified parameters.

Example: Consider an example where the "Insert or Delete Rows" activity is used to insert three rows starting from the third row index:

Insert or Delete Rows:
  ActionType: Insert
  Index: 2
  NoOfRows: 3
  Delay: 2

In this example, the activity inserts three rows starting from the third row index. The delay is set to 2 seconds, allowing time for any required synchronization.

Note: Ensure that the "Insert or Delete Rows" activity is placed within an "Excel Root" activity to establish the Excel context for execution.